Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$SPPARAMETER

`V$SPPARAMETER` displays information about the contents of the server parameter file. If a server parameter file was not used to start the instance, then each row of the view will contain `FALSE` in the `ISSPECIFIED` column.

Column | Datatype | Description
--- | --- | ---
`SID` | `VARCHAR2(80)` | SID for which the parameter is defined
`NAME` | `VARCHAR2(80)` | Name of the parameter
`VALUE` | `VARCHAR2(255)` | Parameter value (null if a server parameter file was not used to start the instance)
`DISPLAY_VALUE` | `VARCHAR2(255)` | Parameter value in a user-friendly format. For example, if the `VALUE` column shows the value `262144` for a big integer parameter, then the `DISPLAY_VALUE` column will show the value `256K`.
`ISSPECIFIED` | `VARCHAR2(6)` | Indicates whether the parameter was specified in the server parameter file (`TRUE`) or not (`FALSE`)
`ORDINAL` | `NUMBER` | Position (ordinal number) of the parameter value (`0` if a server parameter file was not used to start the instance). Useful only for parameters whose values are lists of strings.
`UPDATE_COMMENT` | `VARCHAR2(255)` | Comments associated with the most recent update (null if a server parameter file was not used to start the instance)